package com.qf.j2112.mapper;

import java.util.List;
import com.qf.j2112.po.SysGoods;

public interface SysGoodsMapper {

    //根据商品id查询单个商品
    SysGoods selectSysGoodsByGoodsId(Integer goodsId);

    //查询热门商品列表
    List<SysGoods> selectHotSysGoodsList();

    //全查商品
    List<SysGoods> selectAll();

    //根据商品类型全查商品
    List<SysGoods> selectAllByType(Integer typeId);


    // 新增商品
    int insertSysGoods(SysGoods sysGoods);

    //修改商品
    int updateSysGoods(SysGoods sysGoods);

    //删除商品
    int deleteSysGoodsByGoodsId(Integer goodsId);

    //批量删除商品
    int deleteSysGoodsByGoodsIds(Integer[] goodsIds);
}
